UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C3crz5IMEa+yltY7D3rAIzNofZt9fuOj3EqjKG+GGTU='
WHERE
key_id = '0f423a9c192f692702b8544dfc69a0001f326c6377076353f5c0be449b76e028'
AND (
token = 'C3crz5IMEa+yltY7D3rAIzNofZt9fuOj3EqjKG+GGTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)