UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't/5KLjlo9wVIKOf1xwyE7ELmuhPsaHRZj0NyS7hY8iM='
WHERE
key_id = 'a0b989547d6fbafae5d7fbaac0590138f6ab91e7719793dc6dc63d88062b46b4'
AND (
token = 't/5KLjlo9wVIKOf1xwyE7ELmuhPsaHRZj0NyS7hY8iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)