UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+pDJVrMYnIKCBYgYv8zMt5Zu1kHg1mZ7hiPU1XKIis='
WHERE
key_id = '47795d6c1a66cff90239c4a54552f3e81f154c173df22d0c966c5b420b0f4e11'
AND (
token = '9+pDJVrMYnIKCBYgYv8zMt5Zu1kHg1mZ7hiPU1XKIis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)