UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5oS7InpH2PFDro97dgrvUpnOGdwOLgv13Q2+rYHw4Hg='
WHERE
key_id = 'bce39ce53800b357198107839772a8e8300f287b41253a7b1f211d43da9205b7'
AND (
token = '5oS7InpH2PFDro97dgrvUpnOGdwOLgv13Q2+rYHw4Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)