UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yn7XdKJ/2gFxKnHT+7uh0LRmYHA9fklOB82jTjY01Bk='
WHERE
key_id = 'caaef27b4a46761e7cc02923d3d0a5e8ea5b32aa999b25d95de994dcdac48ae0'
AND (
token = 'Yn7XdKJ/2gFxKnHT+7uh0LRmYHA9fklOB82jTjY01Bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)