UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLzHBPbf0FtpsxGtUX92y+/Kb29e84vtX/R2bhK6IJw='
WHERE
key_id = 'efc36dde582003bbd5cad8ccc8bf447fe75d7978f27d83d816d7b2c9ac7a3f99'
AND (
token = 'xLzHBPbf0FtpsxGtUX92y+/Kb29e84vtX/R2bhK6IJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)