UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4kwwVXe0dJtFpZ981kDlUwskUYK0WSvRlmtvsuSyRs='
WHERE
key_id = '10dcbc3a194de3a1ad3a9cadbb527700fcdbc12161b17dea90274a11120e2a9b'
AND (
token = 'B4kwwVXe0dJtFpZ981kDlUwskUYK0WSvRlmtvsuSyRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)