UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQuzbgTKXc4vYlB6XVV8PKuWGl/mpXXJ+ONGkRyIkr8='
WHERE
key_id = 'a54cbeaf8de02df7aae2bedc3c2586df7c6100c99b7e3a65532422187ef99c3d'
AND (
token = 'xQuzbgTKXc4vYlB6XVV8PKuWGl/mpXXJ+ONGkRyIkr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)