UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gi2F4nxXNzhqv9Iz/mu3c8uan8LgfL93Ey9wOV1Du4k=' 
WHERE 
  key_id = 'c361754869d6fdcac4992844acb6a780fd55892899817b146ba3ce5caaf86943' 
  AND (
    token = 'Gi2F4nxXNzhqv9Iz/mu3c8uan8LgfL93Ey9wOV1Du4k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034