UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7mRg4+rdgrmKo6PMwDwm/snCUlPiVohkrscjjg+Tx8='
WHERE
key_id = 'ffb4fcd550dd348ebd74572dff8469ffd7adbc205b828898601963c4b314b418'
AND (
token = 'G7mRg4+rdgrmKo6PMwDwm/snCUlPiVohkrscjjg+Tx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)