UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gMltPan++4m7IHlz5QNnES0q+gIHuiBll6fXBNSGxg='
WHERE
key_id = '31d1b97cd2768f4dd632dadbe8cabeb9f6ba57fcab84c6e17a5a8d9c3315a126'
AND (
token = '6gMltPan++4m7IHlz5QNnES0q+gIHuiBll6fXBNSGxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)