UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZEf3wIVnkPVw6ejEDFDs8VvPgBHGwLAN2WWL3hRAakU='
WHERE
key_id = '2a3a6cd5b4e1a7a5512e6d3dffc96b4c9cea1b94948ce53faf52eded0abb4a11'
AND (
token = 'ZEf3wIVnkPVw6ejEDFDs8VvPgBHGwLAN2WWL3hRAakU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)