UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y475j/SjEky770xCXmo73UjTFLavIwVOcyT776LLCKs='
WHERE
key_id = '1a114a0965dc60e306baee7200c209638e72e9fe72e7cf39ed21da2ca670d747'
AND (
token = 'y475j/SjEky770xCXmo73UjTFLavIwVOcyT776LLCKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)