UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3q8oCxo3KjkJ78OS7PaUSJY+3wq67l3yIJsa9KNGqf8='
WHERE
key_id = 'bbf9dc0128d8336d7aedf64aa8fa5fef3df36be39a5c47b0909d61042c34f197'
AND (
token = '3q8oCxo3KjkJ78OS7PaUSJY+3wq67l3yIJsa9KNGqf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)