UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lHM8Cw3L8nclcGEWk5W1qM3tNv9yvHNy5X3fYE4Iurg=' 
WHERE 
  key_id = 'faaf7ff92e1343c7f27dbe44b6bd31b3ac2d5c556396aa33ffb1951f27de6fbe' 
  AND (
    token = 'lHM8Cw3L8nclcGEWk5W1qM3tNv9yvHNy5X3fYE4Iurg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024