UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tx8Vsva2Br08nFS5kQ+8IBqOt+3bFzAPSU/fBsutvAk='
WHERE
key_id = 'b8e33dd6a900ccf8a08b907eecf9333c7bed67c4a22a14c54528f7c9bd66d419'
AND (
token = 'tx8Vsva2Br08nFS5kQ+8IBqOt+3bFzAPSU/fBsutvAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)