UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7HzB3qKVrMS7YglNEafSCO0K8NkmjSpaDMVtx4ZDQk='
WHERE
key_id = '290d677e96606832897cee2c8f4dcf3bf7f88286c8f24bf7ceb83e51e39b7f5c'
AND (
token = 'd7HzB3qKVrMS7YglNEafSCO0K8NkmjSpaDMVtx4ZDQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)