SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '77ac5ee748e8ea0e7f7499728c62988f1f994c5b81c574634f62307e1a9b19e7' 
  AND token = '3gBASjT4WyNWttPOFp69kFBMN37B+TbUEYvJbI+1WeM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}