UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xvxhSiCOo8DAovBaKz0tICX01x2UCVjp9LZPgZjoM8Q='
WHERE
key_id = '8fad2f9dcf426f3ff454a52ff72311dbc0992023de1b6ee14320c7e9c9d3be57'
AND (
token = 'xvxhSiCOo8DAovBaKz0tICX01x2UCVjp9LZPgZjoM8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)