UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+VDKlPXrF4LSHI/Psjj94a57eSZjfKq+OxKY4DFDpsA='
WHERE
key_id = 'c2ebfbcebb5743636b1ef65507ae9fe867c3cb80ac1f62b8f1e2b3a37bdc7fd3'
AND (
token = '+VDKlPXrF4LSHI/Psjj94a57eSZjfKq+OxKY4DFDpsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)