UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UEf6acj+mprQYsdLMAGhTZl8kSkCmWRtATH2bkxU09o='
WHERE
key_id = '9a120dbc847187a73dbe81a653dc47264baf4d926def26f43b19253e0eb8098b'
AND (
token = 'UEf6acj+mprQYsdLMAGhTZl8kSkCmWRtATH2bkxU09o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)