UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSR0d1nMuN1bPaSVIYRIKqM1GllGCNVvKzC6mLD8YzE='
WHERE
key_id = 'd8dee1a5bb9861a49bde6654a3bb956ee8dcc9652e521b3fd411cecef422bd46'
AND (
token = 'bSR0d1nMuN1bPaSVIYRIKqM1GllGCNVvKzC6mLD8YzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)