UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yUSQiBgMfCFlHnvifC0y1qv0Ovw4CYhEr9L7PjGJ8s='
WHERE
key_id = '378610c9144339636edeeb310c70e25c862391aecb9dea1bc733f259a906884f'
AND (
token = '7yUSQiBgMfCFlHnvifC0y1qv0Ovw4CYhEr9L7PjGJ8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)