UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j2sGMhP07FWrDWL8OO0lbhOGVI0ledCWBjzcYQq1YXY='
WHERE
key_id = '6d7e24e38193f481995c82e8505e4a0ba61af21bab259ee23e827a7f41313de6'
AND (
token = 'j2sGMhP07FWrDWL8OO0lbhOGVI0ledCWBjzcYQq1YXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)