UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHON9ah1W6NneVeiDJ1Z5S4NGBLwQC+xBtyOmkJJhvM='
WHERE
key_id = '0bf6b96342f5ae9b14e9b6dd4c971dea2d162350acb7ed2aaaa50cbf7d4a9e84'
AND (
token = 'hHON9ah1W6NneVeiDJ1Z5S4NGBLwQC+xBtyOmkJJhvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)