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