UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vogg+gJZRr+QETyPxP0iyw83FIJJZ1R/9M7oTfehJo8=' 
WHERE 
  key_id = '7fde2ded52e6a0a80dfaef60c3cc94d769cb4be11424ff4ab8bc96ea9df69433' 
  AND (
    token = 'Vogg+gJZRr+QETyPxP0iyw83FIJJZ1R/9M7oTfehJo8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035