UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tW6VHFEm6fdKvIO/BQL1jv28JHUME4HU/Bf7llyYJCk='
WHERE
key_id = '0a4b288c6ad66065ef2ac3b31ed8afd0022e36df7751b143e443da85717f54c6'
AND (
token = 'tW6VHFEm6fdKvIO/BQL1jv28JHUME4HU/Bf7llyYJCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)