UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GRgMlCPRDRSeZMCrnYpaTYOnCYwVtdifDvpiZdxJ378='
WHERE
key_id = '38f96b0e08487c5d7fc30b92d0b7dd69ad791c4aea0d716d9563f5d5bf43fcd2'
AND (
token = 'GRgMlCPRDRSeZMCrnYpaTYOnCYwVtdifDvpiZdxJ378='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)