UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khHYx/SzEcA2BtaCyp27r8oRQ8iyQ6ucpTWyTGkGcCc='
WHERE
key_id = 'ca07d80ebf9c35e00a9230d4963bc4bb298328296c4cca8a497d70c1805f2a21'
AND (
token = 'khHYx/SzEcA2BtaCyp27r8oRQ8iyQ6ucpTWyTGkGcCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)