UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TE8cqHDw3ueuS4HiPIJ9KOBJpLd/PfTmqwFaa8OTYc='
WHERE
key_id = 'a9cc855f5b010bfc5ade01a777ae47e1bae5aeb97a9f77dca44f43cca9028355'
AND (
token = '6TE8cqHDw3ueuS4HiPIJ9KOBJpLd/PfTmqwFaa8OTYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)